<?php
namespace Home\Model;
use Think\Model;
class ScreeningModel extends Model
{
    public function getAll($showtime,$limit){
        $list=$this->field('s.id sid,u.name uname,m.name mname,r.name rname, s.showtime stime,s.price sprice')
            ->table('pre_user u,pre_movie m,pre_room r,pre_screening s')
            ->where("u.id = s.user_id
					and
					m.id = s.movie_id
					and
					r.id = s.room_id and s.showtime like'%$showtime%'")
            ->order("s.showtime")
            ->limit($limit)
            ->select();
        return $list;

    }
}

